Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	35283
Missing cells	221
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.8 MiB
Average record size in memory	172.0 B

Variable types

NUM	18
CAT	3
BOOL	1

Warnings

`'Single Flank Tester Spiral Angle Pinion'` has constant value "35283"	Constant
`M47BPDXX_DISTANCE_DE_TO_F_SEAT` is highly correlated with `M46BPDXX_DISTANCE_D_SEAT_TO_FG` and 1 other fields	High correlation
`M46BPDXX_DISTANCE_D_SEAT_TO_FG` is highly correlated with `M47BPDXX_DISTANCE_DE_TO_F_SEAT` and 1 other fields	High correlation
`M48BPDXX_DISTANCE_DE_TO_G_SEAT` is highly correlated with `M46BPDXX_DISTANCE_D_SEAT_TO_FG` and 1 other fields	High correlation
`'Diff Shim Gage Ring Side Verifier Measurement'` is highly correlated with `'Diff Shim Gage Pinion Side Verifier Measurement'`	High correlation
`'Diff Shim Gage Pinion Side Verifier Measurement'` is highly correlated with `'Diff Shim Gage Ring Side Verifier Measurement'`	High correlation
`'Ring Gear Press Distance'` is highly correlated with `'Lower Diff Bearing Press Distance'`	High correlation
`'Lower Diff Bearing Press Distance'` is highly correlated with `'Ring Gear Press Distance'`	High correlation
`'Pinion Tail Bearing Cup Press Distance'` is highly correlated with `'Pinion Head Bearing Cup Press Distance'`	High correlation
`'Pinion Head Bearing Cup Press Distance'` is highly correlated with `'Pinion Tail Bearing Cup Press Distance'`	High correlation
`M46BPDXX_DISTANCE_D_SEAT_TO_FG` is highly skewed (γ1 = -66.68609427)	Skewed
`M47BPDXX_DISTANCE_DE_TO_F_SEAT` is highly skewed (γ1 = -66.62712402)	Skewed
`M48BPDXX_DISTANCE_DE_TO_G_SEAT` is highly skewed (γ1 = -66.46313548)	Skewed
`'SFT 1st Mesh Harmonic Drive Side Pos 1 Val (µrad)'` is highly skewed (γ1 = 141.1680566)	Skewed
`'SFT 1st Mesh Harmonic Coast Side Pos 1 Val (µrad)'` is highly skewed (γ1 = 183.5348317)	Skewed
`'Diff Shim Gage Ring Side Verifier Measurement'` is highly skewed (γ1 = 65.90495674)	Skewed
`df_index` has unique values	Unique

Reproduction

Analysis started	2020-10-11 13:28:58.536009
Analysis finished	2020-10-11 13:30:52.618462
Duration	1 minute and 54.08 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	35283
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	44374.15379
Minimum	0
Maximum	92979
Zeros	1
Zeros (%)	< 0.1%
Memory size	275.6 KiB

Quantile statistics

Minimum	0
5-th percentile	4626.1
Q1	22008.5
median	43222
Q3	66293
95-th percentile	87393.9
Maximum	92979
Range	92979
Interquartile range (IQR)	44284.5

Descriptive statistics

Standard deviation	26145.35911
Coefficient of variation (CV)	0.5892024271
Kurtosis	-1.134892577
Mean	44374.15379
Median Absolute Deviation (MAD)	21928
Skewness	0.1138243384
Sum	1565653268
Variance	683579803.1
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69630	1	< 0.1%
42142	1	< 0.1%
7337	1	< 0.1%
27815	1	< 0.1%
91302	1	< 0.1%
31909	1	< 0.1%
19619	1	< 0.1%
21664	1	< 0.1%
48285	1	< 0.1%
11471	1	< 0.1%
Other values (35273)	35273	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
92979	1	< 0.1%
92978	1	< 0.1%
92977	1	< 0.1%
92976	1	< 0.1%
92975	1	< 0.1%

M46BPDXX_DISTANCE_D_SEAT_TO_FG
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	622
Distinct (%)	1.8%
Missing	15
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	158.488451
Minimum	105.6446667
Maximum	158.608
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	105.6446667
5-th percentile	158.4662792
Q1	158.488
median	158.499
Q3	158.509
95-th percentile	158.53
Maximum	158.608
Range	52.96333333
Interquartile range (IQR)	0.021

Descriptive statistics

Standard deviation	0.6373580271
Coefficient of variation (CV)	0.004021479313
Kurtosis	4639.348743
Mean	158.488451
Median Absolute Deviation (MAD)	0.011
Skewness	-66.68609427
Sum	5589570.69
Variance	0.4062252548
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
158.503	965	2.7%
158.501	914	2.6%
158.499	897	2.5%
158.495	849	2.4%
158.497	835	2.4%
158.492	787	2.2%
158.5	786	2.2%
158.505	781	2.2%
158.504	769	2.2%
158.498	768	2.2%
Other values (612)	26917	76.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
105.6446667	1	< 0.1%
105.663	1	< 0.1%
118.86275	1	< 0.1%
118.863	1	< 0.1%
118.8735	1	< 0.1%

Value	Count	Frequency (%)
158.608	1	< 0.1%
158.604	1	< 0.1%
158.603	2	< 0.1%
158.602	1	< 0.1%
158.6015	1	< 0.1%

M47BPDXX_DISTANCE_DE_TO_F_SEAT
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	672
Distinct (%)	1.9%
Missing	15
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	142.4875284
Minimum	94.974
Maximum	142.6105
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	94.974
5-th percentile	142.458
Q1	142.4825
median	142.4975
Q3	142.511
95-th percentile	142.532
Maximum	142.6105
Range	47.6365
Interquartile range (IQR)	0.0285

Descriptive statistics

Standard deviation	0.5731587068
Coefficient of variation (CV)	0.004022518416
Kurtosis	4634.134775
Mean	142.4875284
Median Absolute Deviation (MAD)	0.0145
Skewness	-66.62712402
Sum	5025250.15
Variance	0.3285109032
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
142.503	687	1.9%
142.497	675	1.9%
142.495	657	1.9%
142.499	638	1.8%
142.501	635	1.8%
142.508	634	1.8%
142.492	628	1.8%
142.505	628	1.8%
142.5	599	1.7%
142.493	593	1.7%
Other values (662)	28894	81.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
94.974	1	< 0.1%
94.99766667	1	< 0.1%
106.8605	1	< 0.1%
106.86325	1	< 0.1%
106.8785	1	< 0.1%

Value	Count	Frequency (%)
142.6105	1	< 0.1%
142.6026667	2	< 0.1%
142.598	1	< 0.1%
142.597	1	< 0.1%
142.596	1	< 0.1%

M48BPDXX_DISTANCE_DE_TO_G_SEAT
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	698
Distinct (%)	2.0%
Missing	15
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	105.0268829
Minimum	70.01533333
Maximum	105.1423333
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	70.01533333
5-th percentile	104.996
Q1	105.019
median	105.033
Q3	105.0475
95-th percentile	105.073
Maximum	105.1423333
Range	35.127
Interquartile range (IQR)	0.0285

Descriptive statistics

Standard deviation	0.4228259773
Coefficient of variation (CV)	0.004025883333
Kurtosis	4617.601617
Mean	105.0268829
Median Absolute Deviation (MAD)	0.014
Skewness	-66.46313548
Sum	3704088.106
Variance	0.1787818071
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
105.035	659	1.9%
105.031	658	1.9%
105.03	642	1.8%
105.026	641	1.8%
105.036	611	1.7%
105.034	610	1.7%
105.033	606	1.7%
105.032	603	1.7%
105.024	597	1.7%
105.029	592	1.7%
Other values (688)	29049	82.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
70.01533333	1	< 0.1%
70.03566667	1	< 0.1%
78.74475	1	< 0.1%
78.7685	1	< 0.1%
78.78575	1	< 0.1%

Value	Count	Frequency (%)
105.1423333	1	< 0.1%
105.1373333	1	< 0.1%
105.133	1	< 0.1%
105.129	1	< 0.1%
105.128	1	< 0.1%

PERP_OF_AXIS_DAT_FG_TO_AXIS_DAT_DE_DAT_B_TWO_COAXIAL_HOLES
Real number (ℝ_≥0)

Distinct	2704
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.04316657644
Minimum	0
Maximum	0.1335
Zeros	13
Zeros (%)	< 0.1%
Memory size	275.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0064
Q1	0.0259
median	0.04385
Q3	0.0602
95-th percentile	0.0783
Maximum	0.1335
Range	0.1335
Interquartile range (IQR)	0.0343

Descriptive statistics

Standard deviation	0.02223043781
Coefficient of variation (CV)	0.5149919136
Kurtosis	-0.7648919357
Mean	0.04316657644
Median Absolute Deviation (MAD)	0.0171166667
Skewness	0.01436215398
Sum	1523.046317
Variance	0.0004941923651
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0533	68	0.2%
0.0559	67	0.2%
0.0541	67	0.2%
0.0573	65	0.2%
0.057	64	0.2%
0.0464	64	0.2%
0.053	64	0.2%
0.0514	63	0.2%
0.0499	62	0.2%
0.0425	62	0.2%
Other values (2694)	34637	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13	< 0.1%
0.0001	24	0.1%
0.00015	1	< 0.1%
0.0002	25	0.1%
0.0003	30	0.1%

Value	Count	Frequency (%)
0.1335	1	< 0.1%
0.1244	1	< 0.1%
0.11975	1	< 0.1%
0.1175	1	< 0.1%
0.1169	1	< 0.1%

'Backlash Result'
Real number (ℝ_≥0)

Distinct	27
Distinct (%)	0.1%
Missing	13
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	0.3132664966
Minimum	0
Maximum	0.33
Zeros	154
Zeros (%)	0.4%
Memory size	275.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2
Q1	0.33
median	0.33
Q3	0.33
95-th percentile	0.33
Maximum	0.33
Range	0.33
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.04710521788
Coefficient of variation (CV)	0.1503678766
Kurtosis	10.200801
Mean	0.3132664966
Median Absolute Deviation (MAD)	0
Skewness	-3.018710038
Sum	11048.90933
Variance	0.002218901552
Monotocity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0.33	30886	87.5%
0.2	3240	9.2%
0.165	464	1.3%
0.265	276	0.8%
0	154	0.4%
0.22	43	0.1%
0.2866666667	42	0.1%
0.225	38	0.1%
0.25	26	0.1%
0.2433333333	19	0.1%
Other values (17)	82	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	154	0.4%
0.1	15	< 0.1%
0.11	3	< 0.1%
0.1325	1	< 0.1%
0.165	464	1.3%

Value	Count	Frequency (%)
0.33	30886	87.5%
0.304	2	< 0.1%
0.3033333333	5	< 0.1%
0.2975	1	< 0.1%
0.29	13	< 0.1%

'Single Flank Tester Deviation J for Best Position'
Real number (ℝ)

Distinct	6596
Distinct (%)	18.7%
Missing	21
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	0.03157285966
Minimum	-0.5301
Maximum	0.4548
Zeros	12
Zeros (%)	< 0.1%
Memory size	275.6 KiB

Quantile statistics

Minimum	-0.5301
5-th percentile	-0.172
Q1	-0.046975
median	0.0331
Q3	0.1103
95-th percentile	0.2250975
Maximum	0.4548
Range	0.9849
Interquartile range (IQR)	0.157275

Descriptive statistics

Standard deviation	0.1181089513
Coefficient of variation (CV)	3.740837939
Kurtosis	-0.07183123284
Mean	0.03157285966
Median Absolute Deviation (MAD)	0.0789
Skewness	-0.1382851431
Sum	1113.322177
Variance	0.01394972437
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0494	23	0.1%
0.055	23	0.1%
-0.0135	23	0.1%
0.0136	23	0.1%
0.0304	22	0.1%
0.068	22	0.1%
0.0673	22	0.1%
0.022	22	0.1%
0.0519	22	0.1%
0.0487	21	0.1%
Other values (6586)	35039	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.5301	1	< 0.1%
-0.4907	1	< 0.1%
-0.484	1	< 0.1%
-0.4826	1	< 0.1%
-0.4749	1	< 0.1%

Value	Count	Frequency (%)
0.4548	1	< 0.1%
0.4415	1	< 0.1%
0.4154	1	< 0.1%
0.41045	1	< 0.1%
0.4077	1	< 0.1%

'SFT 1st Mesh Harmonic Drive Side Pos 1 Val (µrad)'
Real number (ℝ_≥0)

SKEWED

Distinct	24475
Distinct (%)	69.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.086782103
Minimum	0.0183
Maximum	15196.545
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	0.0183
5-th percentile	0.96457
Q1	2.1207
median	3.1308
Q3	4.24075
95-th percentile	6.5999
Maximum	15196.545
Range	15196.5267
Interquartile range (IQR)	2.12005

Descriptive statistics

Standard deviation	96.37390769
Coefficient of variation (CV)	23.58185616
Kurtosis	20578.4629
Mean	4.086782103
Median Absolute Deviation (MAD)	1.0577
Skewness	141.1680566
Sum	144193.9329
Variance	9287.930084
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.79	13	< 0.1%
4.2	12	< 0.1%
4.45	12	< 0.1%
5.74	11	< 0.1%
5.49	11	< 0.1%
5.2	11	< 0.1%
5.3	11	< 0.1%
3.89	11	< 0.1%
4.54	10	< 0.1%
4.31	10	< 0.1%
Other values (24465)	35171	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0183	1	< 0.1%
0.0276	1	< 0.1%
0.0345	1	< 0.1%
0.037	1	< 0.1%
0.0381	1	< 0.1%

Value	Count	Frequency (%)
15196.545	1	< 0.1%
9839.56455	1	< 0.1%
39.385	1	< 0.1%
32.46	1	< 0.1%
28.4876	1	< 0.1%

'SFT 1st Mesh Harmonic Coast Side Pos 1 Val (µrad)'
Real number (ℝ_≥0)

SKEWED

Distinct	24656
Distinct (%)	69.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	3.495769806
Minimum	0.0065
Maximum	3453.195
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	0.0065
5-th percentile	0.9144
Q1	1.988325
median	2.95985
Q3	4.153975
95-th percentile	7.343311667
Maximum	3453.195
Range	3453.1885
Interquartile range (IQR)	2.16565

Descriptive statistics

Standard deviation	18.50861015
Coefficient of variation (CV)	5.294573492
Kurtosis	34207.76051
Mean	3.495769806
Median Absolute Deviation (MAD)	1.06045
Skewness	183.5348317
Sum	123337.7503
Variance	342.5686497
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.29	12	< 0.1%
5.47	10	< 0.1%
7.27	10	< 0.1%
5.23	10	< 0.1%
6.1	9	< 0.1%
6.04	9	< 0.1%
5.36	9	< 0.1%
4.2	9	< 0.1%
6.27	9	< 0.1%
4.45	9	< 0.1%
Other values (24646)	35186	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0065	1	< 0.1%
0.0133	1	< 0.1%
0.0217	1	< 0.1%
0.0294	1	< 0.1%
0.036	1	< 0.1%

Value	Count	Frequency (%)
3453.195	1	< 0.1%
45.2789	1	< 0.1%
43.615	1	< 0.1%
37.22	1	< 0.1%
35.9069	1	< 0.1%

'Single Flank Tester Spiral Angle Pinion'
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	275.6 KiB

51.083	35283

Frequencies
Length

Value	Count	Frequency (%)
51.083	35283	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	6
Median length	6
Mean length	6
Min length	6

'Single Flank Tester Spiral Angle Ring Gear'
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	275.6 KiB

25.066	34689
25.866	594

Frequencies
Length

Value	Count	Frequency (%)
25.066	34689	98.3%
25.866	594	1.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	6
Median length	6
Mean length	6
Min length	6

'Diff Shim Gage Pinion Side Verifier Measurement'
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	275.6 KiB

6	35269
5002.5	6
2504.25	4
4	4

Frequencies
Length

Value	Count	Frequency (%)
6	35269	> 99.9%
5002.5	6	< 0.1%
2504.25	4	< 0.1%
4	4	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	3
Mean length	3.000963637
Min length	3

'Diff Shim Gage Ring Side Verifier Measurement'
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.132689019
Minimum	4
Maximum	5002.5
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	4
5-th percentile	6
Q1	6
median	6
Q3	6
95-th percentile	6
Maximum	5002.5
Range	4998.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	70.36911324
Coefficient of variation (CV)	9.865720074
Kurtosis	4496.10676
Mean	7.132689019
Median Absolute Deviation (MAD)	0
Skewness	65.90495674
Sum	251662.6667
Variance	4951.812098
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
6	35267	> 99.9%
5002.5	6	< 0.1%
2504.25	4	< 0.1%
4	4	< 0.1%
6.333333	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	4	< 0.1%
6	35267	> 99.9%
6.333333	2	< 0.1%
2504.25	4	< 0.1%
5002.5	6	< 0.1%

Value	Count	Frequency (%)
5002.5	6	< 0.1%
2504.25	4	< 0.1%
6.333333	2	< 0.1%
6	35267	> 99.9%
4	4	< 0.1%

'Pinion Torque to Rotate Audit (PTR - without diff case)'
Real number (ℝ_≥0)

Distinct	11
Distinct (%)	< 0.1%
Missing	43
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	3.291486946
Minimum	1.5
Maximum	5
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	1.5
5-th percentile	3
Q1	3
median	3
Q3	4
95-th percentile	4
Maximum	5
Range	3.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.559366384
Coefficient of variation (CV)	0.16994337
Kurtosis	0.4148272368
Mean	3.291486946
Median Absolute Deviation (MAD)	0
Skewness	0.5695729032
Sum	115992
Variance	0.3128907516
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
3	22708	64.4%
4	9961	28.2%
2	1250	3.5%
5	648	1.8%
3.5	513	1.5%
2.5	85	0.2%
3.333333	35	0.1%
4.5	24	0.1%
3.666667	11	< 0.1%
2.666667	3	< 0.1%
(Missing)	43	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.5	2	< 0.1%
2	1250	3.5%
2.5	85	0.2%
2.666667	3	< 0.1%
3	22708	64.4%

Value	Count	Frequency (%)
5	648	1.8%
4.5	24	0.1%
4	9961	28.2%
3.666667	11	< 0.1%
3.5	513	1.5%

'Pinion Position'
Real number (ℝ_≥0)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	127.0882153
Minimum	126
Maximum	129
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	126
5-th percentile	127
Q1	127
median	127
Q3	127
95-th percentile	128
Maximum	129
Range	3
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2839238889
Coefficient of variation (CV)	0.002234069369
Kurtosis	6.968799073
Mean	127.0882153
Median Absolute Deviation (MAD)	0
Skewness	2.897657322
Sum	4484053.5
Variance	0.0806127747
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
127	32041	90.8%
128	2993	8.5%
127.5	208	0.6%
126	15	< 0.1%
129	14	< 0.1%
127.333333	6	< 0.1%
126.5	3	< 0.1%
127.666667	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
126	15	< 0.1%
126.5	3	< 0.1%
127	32041	90.8%
127.333333	6	< 0.1%
127.5	208	0.6%

Value	Count	Frequency (%)
129	14	< 0.1%
128	2993	8.5%
127.666667	3	< 0.1%
127.5	208	0.6%
127.333333	6	< 0.1%

'Pinion Head dist real'
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	77.0463396
Minimum	76
Maximum	79
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	76
5-th percentile	77
Q1	77
median	77
Q3	77
95-th percentile	77.5
Maximum	79
Range	3
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2298962753
Coefficient of variation (CV)	0.002983870182
Kurtosis	14.18638209
Mean	77.0463396
Median Absolute Deviation (MAD)	0
Skewness	3.117981795
Sum	2718426
Variance	0.05285229741
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
77	33213	94.1%
78	1706	4.8%
77.5	175	0.5%
76	168	0.5%
77.333333	9	< 0.1%
76.5	7	< 0.1%
79	5	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
76	168	0.5%
76.5	7	< 0.1%
77	33213	94.1%
77.333333	9	< 0.1%
77.5	175	0.5%

Value	Count	Frequency (%)
79	5	< 0.1%
78	1706	4.8%
77.5	175	0.5%
77.333333	9	< 0.1%
77	33213	94.1%

'Lower Diff Bearing Press Distance'
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	22
Distinct (%)	0.1%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	104.5086644
Minimum	0
Maximum	212
Zeros	2
Zeros (%)	< 0.1%
Memory size	275.6 KiB

Quantile statistics

Minimum	0
5-th percentile	103.5
Q1	103.5
median	103.5
Q3	103.5
95-th percentile	103.5
Maximum	212
Range	212
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.47636265
Coefficient of variation (CV)	0.1002439626
Kurtosis	86.41106214
Mean	104.5086644
Median Absolute Deviation (MAD)	0
Skewness	8.798786918
Sum	3685289.033
Variance	109.7541743
Monotocity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
103.5	34598	98.1%
209	301	0.9%
69	120	0.3%
138	75	0.2%
138.666667	60	0.2%
139.333333	24	0.1%
124.2	15	< 0.1%
125	11	< 0.1%
82.8	10	< 0.1%
139.666667	10	< 0.1%
Other values (12)	39	0.1%
(Missing)	20	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
51.75	2	< 0.1%
69	120	0.3%
82.8	10	< 0.1%
103.5	34598	98.1%

Value	Count	Frequency (%)
212	2	< 0.1%
209	301	0.9%
208	2	< 0.1%
207	7	< 0.1%
184	2	< 0.1%

'Upper Diff Bearing Press Distance'
Real number (ℝ_≥0)

Distinct	18
Distinct (%)	0.1%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	120.233511
Minimum	0
Maximum	240.5
Zeros	11
Zeros (%)	< 0.1%
Memory size	275.6 KiB

Quantile statistics

Minimum	0
5-th percentile	119.5
Q1	119.5
median	119.5
Q3	119.5
95-th percentile	119.5
Maximum	240.5
Range	240.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.0030567
Coefficient of variation (CV)	0.09983120844
Kurtosis	83.86767949
Mean	120.233511
Median Absolute Deviation (MAD)	0
Skewness	7.666855008
Sum	4239794.3
Variance	144.0733702
Monotocity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
119.5	34522	97.8%
239	300	0.9%
79.666667	228	0.6%
159.333333	63	0.2%
95.6	33	0.1%
59.75	30	0.1%
113.75	30	0.1%
120.25	12	< 0.1%
0	11	< 0.1%
179.25	8	< 0.1%
Other values (8)	26	0.1%
(Missing)	20	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11	< 0.1%
47.8	3	< 0.1%
59.75	30	0.1%
79.666667	228	0.6%
95.6	33	0.1%

Value	Count	Frequency (%)
240.5	1	< 0.1%
239	300	0.9%
179.25	8	< 0.1%
160.333333	6	< 0.1%
159.333333	63	0.2%

'Ring Gear Press Distance'
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	38
Distinct (%)	0.1%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	113.1759951
Minimum	0
Maximum	224
Zeros	2
Zeros (%)	< 0.1%
Memory size	275.6 KiB

Quantile statistics

Minimum	0
5-th percentile	111.5
Q1	112
median	112
Q3	112
95-th percentile	112
Maximum	224
Range	224
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.20922651
Coefficient of variation (CV)	0.09904243828
Kurtosis	84.80475226
Mean	113.1759951
Median Absolute Deviation (MAD)	0
Skewness	8.90643476
Sum	3990925.117
Variance	125.646759
Monotocity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
112	27258	77.3%
111.5	6186	17.5%
111.75	611	1.7%
110.75	351	1.0%
224	309	0.9%
149.333333	173	0.5%
110.5	79	0.2%
149	51	0.1%
111.166667	30	0.1%
74.666667	28	0.1%
Other values (28)	187	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
74.333333	2	< 0.1%
74.666667	28	0.1%
89.4	2	< 0.1%
89.6	5	< 0.1%

Value	Count	Frequency (%)
224	309	0.9%
223	9	< 0.1%
168	5	< 0.1%
166.75	5	< 0.1%
166	2	< 0.1%

'Pinion Head Bearing Cup Press Distance'
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	16
Distinct (%)	< 0.1%
Missing	19
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	274.7526051
Minimum	69.75
Maximum	281
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	69.75
5-th percentile	279
Q1	279
median	279
Q3	279
95-th percentile	279
Maximum	281
Range	211.25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	23.66972746
Coefficient of variation (CV)	0.08614923762
Kurtosis	28.39723015
Mean	274.7526051
Median Absolute Deviation (MAD)	0
Skewness	-5.472672129
Sum	9688875.867
Variance	560.2559982
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
279	33974	96.3%
139.5	921	2.6%
281	143	0.4%
186	134	0.4%
280	20	0.1%
93	18	0.1%
178.666667	13	< 0.1%
209.25	12	< 0.1%
134	8	< 0.1%
212.25	4	< 0.1%
Other values (6)	17	< 0.1%
(Missing)	19	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
69.75	2	< 0.1%
93	18	0.1%
134	8	< 0.1%
139.5	921	2.6%
140.333333	4	< 0.1%

Value	Count	Frequency (%)
281	143	0.4%
280	20	0.1%
279	33974	96.3%
212.25	4	< 0.1%
209.25	12	< 0.1%

'Pinion Tail Bearing Cup Press Distance'
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	15
Distinct (%)	< 0.1%
Missing	19
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	231.6755355
Minimum	78.333333
Maximum	239
Zeros	0
Zeros (%)	0.0%
Memory size	275.6 KiB

Quantile statistics

Minimum	78.333333
5-th percentile	235
Q1	235
median	235
Q3	235
95-th percentile	235
Maximum	239
Range	160.666667
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	19.06617467
Coefficient of variation (CV)	0.08229688402
Kurtosis	30.22236888
Mean	231.6755355
Median Absolute Deviation (MAD)	0
Skewness	-5.643321332
Sum	8169806.083
Variance	363.5190167
Monotocity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
235	34150	96.8%
117.5	875	2.5%
156.666667	152	0.4%
238	29	0.1%
176.25	19	0.1%
238.5	9	< 0.1%
239	8	< 0.1%
158.666667	6	< 0.1%
177.75	4	< 0.1%
157.666667	4	< 0.1%
Other values (5)	8	< 0.1%
(Missing)	19	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
78.333333	1	< 0.1%
117.5	875	2.5%
141	3	< 0.1%
156.666667	152	0.4%
157.666667	4	< 0.1%

Value	Count	Frequency (%)
239	8	< 0.1%
238.5	9	< 0.1%
238	29	0.1%
236	1	< 0.1%
235	34150	96.8%

STATUS_ENC
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	137.8 KiB

0	35082
1	201

Common Values
Chart

Value	Count	Frequency (%)
0	35082	99.4%
1	201	0.6%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	df_index	M46BPDXX_DISTANCE_D_SEAT_TO_FG	M47BPDXX_DISTANCE_DE_TO_F_SEAT	M48BPDXX_DISTANCE_DE_TO_G_SEAT	PERP_OF_AXIS_DAT_FG_TO_AXIS_DAT_DE_DAT_B_TWO_COAXIAL_HOLES	'Backlash Result'	'Single Flank Tester Deviation J for Best Position'	'SFT 1st Mesh Harmonic Drive Side Pos 1 Val (µrad)'	'SFT 1st Mesh Harmonic Coast Side Pos 1 Val (µrad)'	'Single Flank Tester Spiral Angle Pinion'	'Single Flank Tester Spiral Angle Ring Gear'	'Diff Shim Gage Pinion Side Verifier Measurement'	'Diff Shim Gage Ring Side Verifier Measurement'	'Pinion Torque to Rotate Audit (PTR - without diff case)'	'Pinion Position'	'Pinion Head dist real'	'Lower Diff Bearing Press Distance'	'Upper Diff Bearing Press Distance'	'Ring Gear Press Distance'	'Pinion Head Bearing Cup Press Distance'	'Pinion Tail Bearing Cup Press Distance'
0	0	158.5025	142.5115	105.0310	0.06390	0.330	0.0145	1.59510	3.06840	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
1	1	158.4980	142.4870	105.0190	0.00880	0.330	0.0277	2.75390	3.15680	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
2	2	158.4850	142.4860	105.0425	0.01305	0.330	0.1445	2.98650	3.65320	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
3	3	158.5055	142.4780	105.0230	0.02975	0.330	0.0019	1.14020	2.05190	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
4	4	158.4710	142.5160	105.0750	0.05240	0.330	-0.0461	0.89060	0.59890	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
5	5	158.4900	142.4980	105.0290	0.02130	0.330	0.0402	0.60060	1.41770	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
6	6	158.5010	142.4960	105.0310	0.07990	0.330	0.0359	0.84900	2.58790	51.083	25.066	6.0	6.0	3.0	127.0	77.0	NaN	NaN	NaN	NaN	NaN
7	7	158.5210	142.5670	104.9780	0.06200	0.330	0.0680	0.93690	2.24890	51.083	25.066	6.0	6.0	3.0	127.0	77.0	NaN	NaN	NaN	NaN	NaN
8	8	158.4840	142.4940	104.9920	0.06130	0.165	0.0934	2.97535	1.81125	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	109.5	279.0	235.0
9	9	158.4840	142.4940	104.9920	0.06130	0.330	0.2973	2.90990	1.49220	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	109.5	279.0	235.0

Last rows

	df_index	M46BPDXX_DISTANCE_D_SEAT_TO_FG	M47BPDXX_DISTANCE_DE_TO_F_SEAT	M48BPDXX_DISTANCE_DE_TO_G_SEAT	PERP_OF_AXIS_DAT_FG_TO_AXIS_DAT_DE_DAT_B_TWO_COAXIAL_HOLES	'Backlash Result'	'Single Flank Tester Deviation J for Best Position'	'SFT 1st Mesh Harmonic Drive Side Pos 1 Val (µrad)'	'SFT 1st Mesh Harmonic Coast Side Pos 1 Val (µrad)'	'Single Flank Tester Spiral Angle Pinion'	'Single Flank Tester Spiral Angle Ring Gear'	'Diff Shim Gage Pinion Side Verifier Measurement'	'Diff Shim Gage Ring Side Verifier Measurement'	'Pinion Torque to Rotate Audit (PTR - without diff case)'	'Pinion Position'	'Pinion Head dist real'	'Lower Diff Bearing Press Distance'	'Upper Diff Bearing Press Distance'	'Ring Gear Press Distance'	'Pinion Head Bearing Cup Press Distance'	'Pinion Tail Bearing Cup Press Distance'
35273	92970	158.500	142.513	105.0180	0.06950	0.33	-0.0357	2.70280	1.3669	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
35274	92971	158.494	142.506	105.0180	0.06560	0.33	-0.0320	3.53970	3.1434	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
35275	92972	158.499	142.511	105.0320	0.01820	0.33	-0.0390	2.69630	2.1587	51.083	25.066	6.0	6.0	4.0	127.0	77.0	103.5	119.5	111.5	279.0	235.0
35276	92973	158.481	142.481	105.0320	0.06585	0.33	-0.0449	2.63930	1.6812	51.083	25.066	6.0	6.0	4.0	127.0	77.0	103.5	119.5	111.5	279.0	235.0
35277	92974	158.493	142.494	105.0210	0.06240	0.20	-0.0695	2.92000	13.9300	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
35278	92975	158.500	142.506	105.0255	0.01635	0.20	-0.0739	3.40000	9.1900	51.083	25.066	6.0	6.0	4.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
35279	92976	158.528	142.481	105.0920	0.04540	0.20	-0.1082	3.91000	7.2800	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	111.5	279.0	235.0
35280	92977	158.480	142.508	105.0470	0.03930	0.20	-0.0856	7.26000	4.2100	51.083	25.066	6.0	6.0	4.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
35281	92978	158.519	142.535	105.0040	0.05930	0.20	-0.1242	3.04000	11.0200	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0
35282	92979	158.476	142.486	105.0190	0.04410	0.33	-0.0229	6.71445	5.7343	51.083	25.066	6.0	6.0	3.0	127.0	77.0	103.5	119.5	112.0	279.0	235.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows